FTFB		v0.4					
Class Name:	Konstantin						
Class Type:	Attack Carrier						
Nationality:	ESU					
Designer:	Jon Tuffley/GZG					
Mass/Cost/ftr:	Listed at End				

Hull&Drives	Rating	Mass %	Mass	Cost	Notes		
Mass Factor	See bottom						
Streamlining	0	=IF(B10<=2,B10*0.1,0)			0-2 (None / Partial / Full)		
Hull Integrity	3	=IF(B11<=5,B11*0.1,0)			1-5 (Fragile / Weak / Avg / Strong / Super)		
Thrust Factor	2	=IF(B12<=10,B12*0.05,0)			1-10 Valid		
FTL	1	=IF(B13=0,0,IF(B13<=2,0.1,0))			0-2 (None / Standard / Tug)		
FTL Tug Cap			=IF(B13=2,FLOOR(0.2*B14+.5),0)	=2*D14	Only applies if FTL is 2		
Screen Level	2	=B15*0.05			Values above 2 provide backup systems		
Armor			=B16	=2*D16	Mass 1 per point		
Weapons	'Number	'X-Arcs					
Class 1 Beam	2		=B18	=3*D18	Mass 1: 6 arcs standard		
Class 2 Beam	4		=2*B19+FLOOR((C19+1)/3+.5)	=3*D19	Mass 2+1 for extra 3 arcs: 3 arcs standard		
Class 3 Beam	4	8	=4*B20+C20	=3*D20	Mass 4+1 per extra arc: 1 arc standard		
Class 4 Beam			=8*B21+2*C21	=3*D21	Mass 8+2 per extra arc: 1 arc standard		
Needle Beam			=2*B22	=3*D22			
Pulse Torp			=4*B23+C23	=3*D23	Mass 4+1 per extra arc: 1 arc standard (3 max)		
SML			=3*B24	=3*D24			
SL Mag			=2*B25	=3*D25	Mass 2 per salvo		
SL Mag (ER)			=3*B26	=3*D26	Mass 3 per salvo		
SMR			=4*B27	=3*D27			
SMR (ER)			=5*B28	=3*D28			
Submun. Pack			=B29	=3*D29			
Missile			=2*B30	=3*D30			
Missile - EMP			=2*B31	=3*D31			
Missile - Needle			=2*B32	=3*D32			
Defense					
PDS	6		=B34	=3*D34	
ADFC			=2*B35	=4*D35	
Other					
Fire Control	2		=B37	=4*D37	
Minelayer			=2*B38	=3*D38	
Mines			=B39	=2*D39	Mass 1 per mine
Minesweeper			=5*B40	=3*D40	
Ortillery			=3*B41	=3*D41	
Hangar Bay			=IF(B42=0,0,FLOOR(1.5*B42+1))	=3*D42	Enter mass of small craft carried
Cargo Space			=B43		Mass devoted to cargo
Passenger Spc			=B44		Mass devoted to Passengers
Troop Space			=B45		Mass devoted to Troops
Ftr Groups					
Standard	6		=9*B47	=27*B47	=18*B47
Heavy			=9*B48	=27*B48	=30*B48
Fast			=9*B49	=27*B49	=24*B49
Interceptor			=9*B50	=27*B50	=18*B50
Attack			=9*B51	=27*B51	=24*B51
Long Range			=9*B52	=27*B52	=24*B52
Torpedo			=9*B53	=27*B53	=36*B53
Heavy Mod.				=12*B54	
Fast Mod.				=6*B55	
LR Mod.				=6*B56	
Totals			Mass	Cost	
			=SUM(D10:D56)	=SUM(E9:E56)	=SUM(F47:F53)

Base % =	=C10+C11+C12+C13	Mod. %=	=IF(B15=0,B60,IF(B62>60,B60+0.05*B15,B60))		
Base Fixed=	=D16+SUM(D18:D53)+IF(B13=2,D14,0)	Mod. Fix=	=IF(B15=0,B61,IF(B62>60,B61,B61+3*B15))		
Base Tot=	=B61/(1-(B60+0.05*B15))	Mod Tot=	=IF(D60>=1,0,D61/(1-D60))		
SL+Integ=	=FLOOR(100*C10*D63+.5)+FLOOR(100*C11*D63+.5)	% Val=	=0.01*D62		
Thrust+FTL=	=FLOOR(100*C12*D63+.5)+FLOOR(100*C13*D63+.5)				
% Shields=	=IF(D62>60,FLOOR(100*C15*D63+.5),0)
Mass Factor	=B63+B64+B65+D61			=B66			
Streamlining			=IF(B10<=2,FLOOR(B10*0.1*B66+.5),0)	=2*D67			
Hull Integrity			=IF(B11<=5,FLOOR(B11*0.1*B66+.5),0)	=2*D68			
Thrust Factor			=IF(B12<=10,FLOOR(B12*0.05*B66+.5),0)	=2*D69			
FTL			=IF(B13=0,0,FLOOR(0.1*B66+.5))	=2*D70			
FTL Tug Cap			=IF(B13=2,FLOOR(0.2*B71+.5),0)	=2*D71
Screen Level			=B15*MAX(3,FLOOR(0.05*B66+.5))	=3*D72			
	
Mass/$/ftr:	=D58+SUM(D67:D72)	=E58+SUM(E66:E72)	=F58
Loaded $	=E74+F74	